package com.ctvit.sms.platform.domain;
import java.util.Date;
import com.ctvit.framework.domain.BaseBean;
/**
* domain类
* 对应查询语句 	SELECT a.*,b.z_sys_name
	FROM
	(
		SELECT a.z_sys_id,SUM(cnt0) AS cnt0,SUM(cnt1) AS cnt1,SUM(cnt2) AS cnt2,SUM(cnt3) AS cnt3,SUM(cnt4) AS cnt4,SUM(cnt5) AS cnt5,SUM(cnt6) AS cnt6,SUM(cnt7) AS cnt7,SUM(cnt8) AS cnt8,SUM(cnt9) AS cnt9
		FROM
		(
			SELECT z_src_sys_id AS z_sys_id,(CASE z_msg_status WHEN '0'  THEN 1 ELSE 0 END ) AS cnt0,(CASE z_msg_status WHEN '1'  THEN 1 ELSE 0 END ) AS cnt1,
			(CASE z_msg_status WHEN '2'  THEN 1 ELSE 0 END ) AS cnt2,(CASE z_msg_status WHEN '3'  THEN 1 ELSE 0 END ) AS cnt3,
			(CASE z_msg_status WHEN '4'  THEN 1 ELSE 0 END ) AS cnt4,(CASE z_msg_status WHEN '5'  THEN 1 ELSE 0 END ) AS cnt5,
			(CASE z_msg_status WHEN '6'  THEN 1 ELSE 0 END ) AS cnt6,(CASE z_msg_status WHEN '7'  THEN 1 ELSE 0 END ) AS cnt7,
			(CASE z_msg_status WHEN '8'  THEN 1 ELSE 0 END ) AS cnt8, 1 AS cnt9
			FROM t_msg_req
			WHERE 1=1

		)AS a GROUP BY a.z_sys_id
	) AS a LEFT JOIN t_recv_system AS b ON a.z_sys_id=b.z_sys_id
	ORDER BY z_sys_id ASC
* 
*/ 
public class ReqStatSys extends BaseBean{
	/*
	* 字段:     z_sys_id 
	* 数据库类型:CHAR 
	* 说明:     null
	* 
	*/
	private String zSysId;
	/*
	* 字段:     cnt0 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt0;
	/*
	* 字段:     cnt1 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt1;
	/*
	* 字段:     cnt2 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt2;
	/*
	* 字段:     cnt3 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt3;
	/*
	* 字段:     cnt4 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt4;
	/*
	* 字段:     cnt5 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt5;
	/*
	* 字段:     cnt6 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt6;
	/*
	* 字段:     cnt7 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt7;
	/*
	* 字段:     cnt8 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt8;
	/*
	* 字段:     cnt9 
	* 数据库类型:DECIMAL 
	* 说明:     null
	* 
	*/
	private Long cnt9;
	/*
	* 字段:     z_sys_name 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zSysName;
	
	/**
	 * null.
	 *
	 * @return ZSysId type:String
	 */
	public String getZSysId() {
		return zSysId;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZSysId(String newvalue) {
		this.zSysId = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt0 type:Long
	 */
	public Long getCnt0() {
		return cnt0;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt0(Long newvalue) {
		this.cnt0 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt1 type:Long
	 */
	public Long getCnt1() {
		return cnt1;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt1(Long newvalue) {
		this.cnt1 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt2 type:Long
	 */
	public Long getCnt2() {
		return cnt2;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt2(Long newvalue) {
		this.cnt2 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt3 type:Long
	 */
	public Long getCnt3() {
		return cnt3;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt3(Long newvalue) {
		this.cnt3 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt4 type:Long
	 */
	public Long getCnt4() {
		return cnt4;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt4(Long newvalue) {
		this.cnt4 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt5 type:Long
	 */
	public Long getCnt5() {
		return cnt5;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt5(Long newvalue) {
		this.cnt5 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt6 type:Long
	 */
	public Long getCnt6() {
		return cnt6;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt6(Long newvalue) {
		this.cnt6 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt7 type:Long
	 */
	public Long getCnt7() {
		return cnt7;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt7(Long newvalue) {
		this.cnt7 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt8 type:Long
	 */
	public Long getCnt8() {
		return cnt8;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt8(Long newvalue) {
		this.cnt8 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt9 type:Long
	 */
	public Long getCnt9() {
		return cnt9;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt9(Long newvalue) {
		this.cnt9 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZSysName type:String
	 */
	public String getZSysName() {
		return zSysName;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZSysName(String newvalue) {
		this.zSysName = newvalue;
	}
}

